﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="ImportPesSalDataSet" targetNamespace="http://tempuri.org/ImportPesSalDataSet.xsd" xmlns:mstns="http://tempuri.org/ImportPesSalDataSet.xsd" xmlns="http://tempuri.org/ImportPesSalDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="ESRPConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ESRPConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.ResUma.Properties.Settings.GlobalReference.Default.ESRPConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Import_PersoaneTableAdapter" GeneratorDataComponentClassName="Import_PersoaneTableAdapter" Name="Import_Persoane" UserDataComponentName="Import_PersoaneTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ESRPConnectionString (Settings)" DbObjectName="ESRP.dbo.Import_Persoane" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Import_Persoane] WHERE (([IdPersoana] = @Original_IdPersoana) AND ([NumePrenume] = @Original_NumePrenume) AND ((@IsNull_Nume_Anterior = 1 AND [Nume_Anterior] IS NULL) OR ([Nume_Anterior] = @Original_Nume_Anterior)) AND ([Cnp] = @Original_Cnp) AND ([Sex] = @Original_Sex) AND ([DataNasterii] = @Original_DataNasterii) AND ([IDLocNastere] = @Original_IDLocNastere) AND ([TipAI] = @Original_TipAI) AND ([SeriaAI] = @Original_SeriaAI) AND ([NumarAI] = @Original_NumarAI) AND ([DataElibAI] = @Original_DataElibAI) AND ([EmitentAI] = @Original_EmitentAI) AND ((@IsNull_NumeTata = 1 AND [NumeTata] IS NULL) OR ([NumeTata] = @Original_NumeTata)) AND ((@IsNull_NumeMama = 1 AND [NumeMama] IS NULL) OR ([NumeMama] = @Original_NumeMama)) AND ([StradaAdr] = @Original_StradaAdr) AND ([IDLocalitateAdr] = @Original_IDLocalitateAdr) AND ([NrAdr] = @Original_NrAdr) AND ([BlocAdr] = @Original_BlocAdr) AND ((@IsNull_EtajAdr = 1 AND [EtajAdr] IS NULL) OR ([EtajAdr] = @Original_EtajAdr)) AND ((@IsNull_ScaraAdr = 1 AND [ScaraAdr] IS NULL) OR ([ScaraAdr] = @Original_ScaraAdr)) AND ([ApartamentAdr] = @Original_ApartamentAdr) AND ((@IsNull_GradInvaliditate = 1 AND [GradInvaliditate] IS NULL) OR ([GradInvaliditate] = @Original_GradInvaliditate)) AND ((@IsNull_TelefonFix = 1 AND [TelefonFix] IS NULL) OR ([TelefonFix] = @Original_TelefonFix)) AND ([TelefonMobil] = @Original_TelefonMobil) AND ((@IsNull_Observatii = 1 AND [Observatii] IS NULL) OR ([Observatii] = @Original_Observatii)) AND ([NumarCM] = @Original_NumarCM) AND ([SerieCM] = @Original_SerieCM) AND ([CodUnitate] = @Original_CodUnitate) AND ([NrFileCM] = @Original_NrFileCM) AND ([NrCutieCM] = @Original_NrCutieCM) AND ([Marca] = @Original_Marca) AND ((@IsNull_TelefonInterior = 1 AND [TelefonInterior] IS NULL) OR ([TelefonInterior] = @Original_TelefonInterior)) AND ([IdCasaAsigSanatate] = @Original_IdCasaAsigSanatate) AND ([IdTipStudii] = @Original_IdTipStudii) AND ([DataVechimeMunca] = @Original_DataVechimeMunca) AND ((@IsNull_UserID = 1 AND [UserID] IS NULL) OR ([UserID] = @Original_UserID)) AND ([PozCutieCM] = @Original_PozCutieCM) AND ([PlatesteCAS] = @Original_PlatesteCAS) AND ([PlatesteCASS] = @Original_PlatesteCASS) AND ([PlatesteSomaj] = @Original_PlatesteSomaj) AND ([PlatesteImpozit] = @Original_PlatesteImpozit) AND ([AreDeducere] = @Original_AreDeducere) AND ((@IsNull_DataPlecarii = 1 AND [DataPlecarii] IS NULL) OR ([DataPlecarii] = @Original_DataPlecarii)) AND ((@IsNull_MotivIncetareContract = 1 AND [MotivIncetareContract] IS NULL) OR ([MotivIncetareContract] = @Original_MotivIncetareContract)) AND ([Operatie] = @Original_Operatie) AND ([Selectat] = @Original_Selectat))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdPersoana" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdPersoana" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NumePrenume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumePrenume" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nume_Anterior" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nume_Anterior" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nume_Anterior" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume_Anterior" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Cnp" Precision="13" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cnp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_Sex" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Sex" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataNasterii" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataNasterii" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDLocNastere" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDLocNastere" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_TipAI" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="TipAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SeriaAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SeriaAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NumarAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumarAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataElibAI" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataElibAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EmitentAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmitentAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NumeTata" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumeTata" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NumeTata" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumeTata" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NumeMama" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumeMama" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NumeMama" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumeMama" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_StradaAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="StradaAdr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDLocalitateAdr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDLocalitateAdr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NrAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NrAdr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BlocAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BlocAdr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EtajAdr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EtajAdr" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EtajAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EtajAdr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ScaraAdr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ScaraAdr" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ScaraAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ScaraAdr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ApartamentAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ApartamentAdr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GradInvaliditate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GradInvaliditate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_GradInvaliditate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="GradInvaliditate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TelefonFix" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TelefonFix" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TelefonFix" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TelefonFix" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TelefonMobil" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TelefonMobil" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Observatii" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Observatii" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Observatii" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Observatii" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NumarCM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumarCM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SerieCM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SerieCM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_NrFileCM" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="NrFileCM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NrCutieCM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NrCutieCM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Marca" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Marca" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TelefonInterior" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TelefonInterior" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TelefonInterior" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TelefonInterior" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_IdCasaAsigSanatate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IdCasaAsigSanatate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdTipStudii" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdTipStudii" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataVechimeMunca" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataVechimeMunca" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_PozCutieCM" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="PozCutieCM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_PlatesteCAS" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlatesteCAS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_PlatesteCASS" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlatesteCASS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_PlatesteSomaj" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlatesteSomaj" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_PlatesteImpozit" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlatesteImpozit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_AreDeducere" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AreDeducere" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataPlecarii" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataPlecarii" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataPlecarii" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataPlecarii" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MotivIncetareContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MotivIncetareContract" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MotivIncetareContract" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MotivIncetareContract" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_Operatie" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Operatie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Selectat" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Selectat" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Import_Persoane] ([NumePrenume], [Nume_Anterior], [Cnp], [Sex], [DataNasterii], [IDLocNastere], [TipAI], [SeriaAI], [NumarAI], [DataElibAI], [EmitentAI], [NumeTata], [NumeMama], [StradaAdr], [IDLocalitateAdr], [NrAdr], [BlocAdr], [EtajAdr], [ScaraAdr], [ApartamentAdr], [GradInvaliditate], [TelefonFix], [TelefonMobil], [Observatii], [NumarCM], [SerieCM], [CodUnitate], [NrFileCM], [NrCutieCM], [Marca], [TelefonInterior], [IdCasaAsigSanatate], [IdTipStudii], [DataVechimeMunca], [UserID], [PozCutieCM], [PlatesteCAS], [PlatesteCASS], [PlatesteSomaj], [PlatesteImpozit], [AreDeducere], [DataPlecarii], [MotivIncetareContract], [Operatie], [Selectat]) VALUES (@NumePrenume, @Nume_Anterior, @Cnp, @Sex, @DataNasterii, @IDLocNastere, @TipAI, @SeriaAI, @NumarAI, @DataElibAI, @EmitentAI, @NumeTata, @NumeMama, @StradaAdr, @IDLocalitateAdr, @NrAdr, @BlocAdr, @EtajAdr, @ScaraAdr, @ApartamentAdr, @GradInvaliditate, @TelefonFix, @TelefonMobil, @Observatii, @NumarCM, @SerieCM, @CodUnitate, @NrFileCM, @NrCutieCM, @Marca, @TelefonInterior, @IdCasaAsigSanatate, @IdTipStudii, @DataVechimeMunca, @UserID, @PozCutieCM, @PlatesteCAS, @PlatesteCASS, @PlatesteSomaj, @PlatesteImpozit, @AreDeducere, @DataPlecarii, @MotivIncetareContract, @Operatie, @Selectat);
SELECT IdPersoana, NumePrenume, Nume_Anterior, Cnp, Sex, DataNasterii, IDLocNastere, TipAI, SeriaAI, NumarAI, DataElibAI, EmitentAI, NumeTata, NumeMama, StradaAdr, IDLocalitateAdr, NrAdr, BlocAdr, EtajAdr, ScaraAdr, ApartamentAdr, GradInvaliditate, TelefonFix, TelefonMobil, Observatii, NumarCM, SerieCM, CodUnitate, NrFileCM, NrCutieCM, Marca, TelefonInterior, IdCasaAsigSanatate, IdTipStudii, DataVechimeMunca, UserID, PozCutieCM, PlatesteCAS, PlatesteCASS, PlatesteSomaj, PlatesteImpozit, AreDeducere, DataPlecarii, MotivIncetareContract, Operatie, Selectat FROM Import_Persoane WHERE (IdPersoana = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NumePrenume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumePrenume" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nume_Anterior" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume_Anterior" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cnp" Precision="13" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cnp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Sex" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Sex" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataNasterii" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataNasterii" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDLocNastere" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDLocNastere" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@TipAI" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="TipAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SeriaAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SeriaAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NumarAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumarAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataElibAI" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataElibAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmitentAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmitentAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NumeTata" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumeTata" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NumeMama" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumeMama" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@StradaAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="StradaAdr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDLocalitateAdr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDLocalitateAdr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NrAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NrAdr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BlocAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BlocAdr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EtajAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EtajAdr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ScaraAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ScaraAdr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ApartamentAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ApartamentAdr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@GradInvaliditate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="GradInvaliditate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TelefonFix" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TelefonFix" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TelefonMobil" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TelefonMobil" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Observatii" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Observatii" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NumarCM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumarCM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SerieCM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SerieCM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@NrFileCM" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="NrFileCM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NrCutieCM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NrCutieCM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Marca" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Marca" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TelefonInterior" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TelefonInterior" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@IdCasaAsigSanatate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IdCasaAsigSanatate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdTipStudii" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdTipStudii" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataVechimeMunca" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataVechimeMunca" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@PozCutieCM" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="PozCutieCM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@PlatesteCAS" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlatesteCAS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@PlatesteCASS" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlatesteCASS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@PlatesteSomaj" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlatesteSomaj" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@PlatesteImpozit" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlatesteImpozit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@AreDeducere" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AreDeducere" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataPlecarii" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataPlecarii" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MotivIncetareContract" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MotivIncetareContract" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Operatie" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Operatie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Selectat" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Selectat" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IdPersoana, NumePrenume, Nume_Anterior, Cnp, Sex, DataNasterii, IDLocNastere, TipAI, SeriaAI, NumarAI, DataElibAI, EmitentAI, NumeTata, NumeMama, StradaAdr, IDLocalitateAdr, NrAdr, BlocAdr, EtajAdr, ScaraAdr, ApartamentAdr, GradInvaliditate, TelefonFix, TelefonMobil, Observatii, NumarCM, SerieCM, CodUnitate, NrFileCM, NrCutieCM, Marca, TelefonInterior, IdCasaAsigSanatate, IdTipStudii, DataVechimeMunca, UserID, PozCutieCM, PlatesteCAS, PlatesteCASS, PlatesteSomaj, PlatesteImpozit, AreDeducere, DataPlecarii, MotivIncetareContract, Operatie, Selectat FROM Import_Persoane</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Import_Persoane] SET [NumePrenume] = @NumePrenume, [Nume_Anterior] = @Nume_Anterior, [Cnp] = @Cnp, [Sex] = @Sex, [DataNasterii] = @DataNasterii, [IDLocNastere] = @IDLocNastere, [TipAI] = @TipAI, [SeriaAI] = @SeriaAI, [NumarAI] = @NumarAI, [DataElibAI] = @DataElibAI, [EmitentAI] = @EmitentAI, [NumeTata] = @NumeTata, [NumeMama] = @NumeMama, [StradaAdr] = @StradaAdr, [IDLocalitateAdr] = @IDLocalitateAdr, [NrAdr] = @NrAdr, [BlocAdr] = @BlocAdr, [EtajAdr] = @EtajAdr, [ScaraAdr] = @ScaraAdr, [ApartamentAdr] = @ApartamentAdr, [GradInvaliditate] = @GradInvaliditate, [TelefonFix] = @TelefonFix, [TelefonMobil] = @TelefonMobil, [Observatii] = @Observatii, [NumarCM] = @NumarCM, [SerieCM] = @SerieCM, [CodUnitate] = @CodUnitate, [NrFileCM] = @NrFileCM, [NrCutieCM] = @NrCutieCM, [Marca] = @Marca, [TelefonInterior] = @TelefonInterior, [IdCasaAsigSanatate] = @IdCasaAsigSanatate, [IdTipStudii] = @IdTipStudii, [DataVechimeMunca] = @DataVechimeMunca, [UserID] = @UserID, [PozCutieCM] = @PozCutieCM, [PlatesteCAS] = @PlatesteCAS, [PlatesteCASS] = @PlatesteCASS, [PlatesteSomaj] = @PlatesteSomaj, [PlatesteImpozit] = @PlatesteImpozit, [AreDeducere] = @AreDeducere, [DataPlecarii] = @DataPlecarii, [MotivIncetareContract] = @MotivIncetareContract, [Operatie] = @Operatie, [Selectat] = @Selectat WHERE (([IdPersoana] = @Original_IdPersoana) AND ([NumePrenume] = @Original_NumePrenume) AND ((@IsNull_Nume_Anterior = 1 AND [Nume_Anterior] IS NULL) OR ([Nume_Anterior] = @Original_Nume_Anterior)) AND ([Cnp] = @Original_Cnp) AND ([Sex] = @Original_Sex) AND ([DataNasterii] = @Original_DataNasterii) AND ([IDLocNastere] = @Original_IDLocNastere) AND ([TipAI] = @Original_TipAI) AND ([SeriaAI] = @Original_SeriaAI) AND ([NumarAI] = @Original_NumarAI) AND ([DataElibAI] = @Original_DataElibAI) AND ([EmitentAI] = @Original_EmitentAI) AND ((@IsNull_NumeTata = 1 AND [NumeTata] IS NULL) OR ([NumeTata] = @Original_NumeTata)) AND ((@IsNull_NumeMama = 1 AND [NumeMama] IS NULL) OR ([NumeMama] = @Original_NumeMama)) AND ([StradaAdr] = @Original_StradaAdr) AND ([IDLocalitateAdr] = @Original_IDLocalitateAdr) AND ([NrAdr] = @Original_NrAdr) AND ([BlocAdr] = @Original_BlocAdr) AND ((@IsNull_EtajAdr = 1 AND [EtajAdr] IS NULL) OR ([EtajAdr] = @Original_EtajAdr)) AND ((@IsNull_ScaraAdr = 1 AND [ScaraAdr] IS NULL) OR ([ScaraAdr] = @Original_ScaraAdr)) AND ([ApartamentAdr] = @Original_ApartamentAdr) AND ((@IsNull_GradInvaliditate = 1 AND [GradInvaliditate] IS NULL) OR ([GradInvaliditate] = @Original_GradInvaliditate)) AND ((@IsNull_TelefonFix = 1 AND [TelefonFix] IS NULL) OR ([TelefonFix] = @Original_TelefonFix)) AND ([TelefonMobil] = @Original_TelefonMobil) AND ((@IsNull_Observatii = 1 AND [Observatii] IS NULL) OR ([Observatii] = @Original_Observatii)) AND ([NumarCM] = @Original_NumarCM) AND ([SerieCM] = @Original_SerieCM) AND ([CodUnitate] = @Original_CodUnitate) AND ([NrFileCM] = @Original_NrFileCM) AND ([NrCutieCM] = @Original_NrCutieCM) AND ([Marca] = @Original_Marca) AND ((@IsNull_TelefonInterior = 1 AND [TelefonInterior] IS NULL) OR ([TelefonInterior] = @Original_TelefonInterior)) AND ([IdCasaAsigSanatate] = @Original_IdCasaAsigSanatate) AND ([IdTipStudii] = @Original_IdTipStudii) AND ([DataVechimeMunca] = @Original_DataVechimeMunca) AND ((@IsNull_UserID = 1 AND [UserID] IS NULL) OR ([UserID] = @Original_UserID)) AND ([PozCutieCM] = @Original_PozCutieCM) AND ([PlatesteCAS] = @Original_PlatesteCAS) AND ([PlatesteCASS] = @Original_PlatesteCASS) AND ([PlatesteSomaj] = @Original_PlatesteSomaj) AND ([PlatesteImpozit] = @Original_PlatesteImpozit) AND ([AreDeducere] = @Original_AreDeducere) AND ((@IsNull_DataPlecarii = 1 AND [DataPlecarii] IS NULL) OR ([DataPlecarii] = @Original_DataPlecarii)) AND ((@IsNull_MotivIncetareContract = 1 AND [MotivIncetareContract] IS NULL) OR ([MotivIncetareContract] = @Original_MotivIncetareContract)) AND ([Operatie] = @Original_Operatie) AND ([Selectat] = @Original_Selectat));
SELECT IdPersoana, NumePrenume, Nume_Anterior, Cnp, Sex, DataNasterii, IDLocNastere, TipAI, SeriaAI, NumarAI, DataElibAI, EmitentAI, NumeTata, NumeMama, StradaAdr, IDLocalitateAdr, NrAdr, BlocAdr, EtajAdr, ScaraAdr, ApartamentAdr, GradInvaliditate, TelefonFix, TelefonMobil, Observatii, NumarCM, SerieCM, CodUnitate, NrFileCM, NrCutieCM, Marca, TelefonInterior, IdCasaAsigSanatate, IdTipStudii, DataVechimeMunca, UserID, PozCutieCM, PlatesteCAS, PlatesteCASS, PlatesteSomaj, PlatesteImpozit, AreDeducere, DataPlecarii, MotivIncetareContract, Operatie, Selectat FROM Import_Persoane WHERE (IdPersoana = @IdPersoana)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NumePrenume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumePrenume" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nume_Anterior" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume_Anterior" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Cnp" Precision="13" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cnp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Sex" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Sex" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataNasterii" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataNasterii" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDLocNastere" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDLocNastere" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@TipAI" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="TipAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SeriaAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SeriaAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NumarAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumarAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataElibAI" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataElibAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EmitentAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmitentAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NumeTata" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumeTata" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NumeMama" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumeMama" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@StradaAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="StradaAdr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDLocalitateAdr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDLocalitateAdr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NrAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NrAdr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BlocAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BlocAdr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EtajAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EtajAdr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ScaraAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ScaraAdr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ApartamentAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ApartamentAdr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@GradInvaliditate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="GradInvaliditate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TelefonFix" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TelefonFix" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TelefonMobil" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TelefonMobil" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Observatii" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Observatii" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NumarCM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumarCM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SerieCM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SerieCM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@NrFileCM" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="NrFileCM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NrCutieCM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NrCutieCM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Marca" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Marca" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TelefonInterior" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TelefonInterior" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@IdCasaAsigSanatate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IdCasaAsigSanatate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdTipStudii" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdTipStudii" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataVechimeMunca" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataVechimeMunca" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@PozCutieCM" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="PozCutieCM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@PlatesteCAS" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlatesteCAS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@PlatesteCASS" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlatesteCASS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@PlatesteSomaj" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlatesteSomaj" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@PlatesteImpozit" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlatesteImpozit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@AreDeducere" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AreDeducere" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DataPlecarii" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataPlecarii" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MotivIncetareContract" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MotivIncetareContract" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Operatie" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Operatie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Selectat" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Selectat" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdPersoana" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdPersoana" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NumePrenume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumePrenume" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nume_Anterior" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nume_Anterior" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nume_Anterior" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume_Anterior" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_Cnp" Precision="13" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="Cnp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_Sex" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Sex" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataNasterii" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataNasterii" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDLocNastere" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDLocNastere" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_TipAI" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="TipAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SeriaAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SeriaAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NumarAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumarAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataElibAI" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataElibAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EmitentAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EmitentAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NumeTata" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumeTata" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NumeTata" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumeTata" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NumeMama" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumeMama" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NumeMama" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumeMama" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_StradaAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="StradaAdr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDLocalitateAdr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDLocalitateAdr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NrAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NrAdr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BlocAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BlocAdr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EtajAdr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EtajAdr" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EtajAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EtajAdr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ScaraAdr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ScaraAdr" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ScaraAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ScaraAdr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ApartamentAdr" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ApartamentAdr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GradInvaliditate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GradInvaliditate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_GradInvaliditate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="GradInvaliditate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TelefonFix" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TelefonFix" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TelefonFix" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TelefonFix" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TelefonMobil" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TelefonMobil" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Observatii" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Observatii" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Observatii" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Observatii" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NumarCM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NumarCM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SerieCM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SerieCM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_CodUnitate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="CodUnitate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_NrFileCM" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="NrFileCM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NrCutieCM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NrCutieCM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Marca" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Marca" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TelefonInterior" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TelefonInterior" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TelefonInterior" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TelefonInterior" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_IdCasaAsigSanatate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IdCasaAsigSanatate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdTipStudii" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IdTipStudii" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataVechimeMunca" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataVechimeMunca" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_PozCutieCM" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="PozCutieCM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_PlatesteCAS" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlatesteCAS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_PlatesteCASS" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlatesteCASS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_PlatesteSomaj" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlatesteSomaj" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_PlatesteImpozit" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="PlatesteImpozit" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_AreDeducere" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AreDeducere" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DataPlecarii" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DataPlecarii" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DataPlecarii" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataPlecarii" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MotivIncetareContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MotivIncetareContract" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MotivIncetareContract" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MotivIncetareContract" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_Operatie" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Operatie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Selectat" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Selectat" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IdPersoana" ColumnName="IdPersoana" DataSourceName="ESRP.dbo.Import_Persoane" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IdPersoana" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IdPersoana" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdPersoana" DataSetColumn="IdPersoana" />
              <Mapping SourceColumn="NumePrenume" DataSetColumn="NumePrenume" />
              <Mapping SourceColumn="Nume_Anterior" DataSetColumn="Nume_Anterior" />
              <Mapping SourceColumn="Cnp" DataSetColumn="Cnp" />
              <Mapping SourceColumn="Sex" DataSetColumn="Sex" />
              <Mapping SourceColumn="DataNasterii" DataSetColumn="DataNasterii" />
              <Mapping SourceColumn="IDLocNastere" DataSetColumn="IDLocNastere" />
              <Mapping SourceColumn="TipAI" DataSetColumn="TipAI" />
              <Mapping SourceColumn="SeriaAI" DataSetColumn="SeriaAI" />
              <Mapping SourceColumn="NumarAI" DataSetColumn="NumarAI" />
              <Mapping SourceColumn="DataElibAI" DataSetColumn="DataElibAI" />
              <Mapping SourceColumn="EmitentAI" DataSetColumn="EmitentAI" />
              <Mapping SourceColumn="NumeTata" DataSetColumn="NumeTata" />
              <Mapping SourceColumn="NumeMama" DataSetColumn="NumeMama" />
              <Mapping SourceColumn="StradaAdr" DataSetColumn="StradaAdr" />
              <Mapping SourceColumn="IDLocalitateAdr" DataSetColumn="IDLocalitateAdr" />
              <Mapping SourceColumn="NrAdr" DataSetColumn="NrAdr" />
              <Mapping SourceColumn="BlocAdr" DataSetColumn="BlocAdr" />
              <Mapping SourceColumn="EtajAdr" DataSetColumn="EtajAdr" />
              <Mapping SourceColumn="ScaraAdr" DataSetColumn="ScaraAdr" />
              <Mapping SourceColumn="ApartamentAdr" DataSetColumn="ApartamentAdr" />
              <Mapping SourceColumn="GradInvaliditate" DataSetColumn="GradInvaliditate" />
              <Mapping SourceColumn="TelefonFix" DataSetColumn="TelefonFix" />
              <Mapping SourceColumn="TelefonMobil" DataSetColumn="TelefonMobil" />
              <Mapping SourceColumn="Observatii" DataSetColumn="Observatii" />
              <Mapping SourceColumn="NumarCM" DataSetColumn="NumarCM" />
              <Mapping SourceColumn="SerieCM" DataSetColumn="SerieCM" />
              <Mapping SourceColumn="CodUnitate" DataSetColumn="CodUnitate" />
              <Mapping SourceColumn="NrFileCM" DataSetColumn="NrFileCM" />
              <Mapping SourceColumn="NrCutieCM" DataSetColumn="NrCutieCM" />
              <Mapping SourceColumn="Marca" DataSetColumn="Marca" />
              <Mapping SourceColumn="TelefonInterior" DataSetColumn="TelefonInterior" />
              <Mapping SourceColumn="IdCasaAsigSanatate" DataSetColumn="IdCasaAsigSanatate" />
              <Mapping SourceColumn="IdTipStudii" DataSetColumn="IdTipStudii" />
              <Mapping SourceColumn="DataVechimeMunca" DataSetColumn="DataVechimeMunca" />
              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
              <Mapping SourceColumn="PozCutieCM" DataSetColumn="PozCutieCM" />
              <Mapping SourceColumn="PlatesteCAS" DataSetColumn="PlatesteCAS" />
              <Mapping SourceColumn="PlatesteCASS" DataSetColumn="PlatesteCASS" />
              <Mapping SourceColumn="PlatesteSomaj" DataSetColumn="PlatesteSomaj" />
              <Mapping SourceColumn="PlatesteImpozit" DataSetColumn="PlatesteImpozit" />
              <Mapping SourceColumn="AreDeducere" DataSetColumn="AreDeducere" />
              <Mapping SourceColumn="DataPlecarii" DataSetColumn="DataPlecarii" />
              <Mapping SourceColumn="MotivIncetareContract" DataSetColumn="MotivIncetareContract" />
              <Mapping SourceColumn="Operatie" DataSetColumn="Operatie" />
              <Mapping SourceColumn="Selectat" DataSetColumn="Selectat" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="ImportPesSalDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="ImportPesSalDataSet" msprop:Generator_UserDSName="ImportPesSalDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Import_Persoane" msprop:Generator_TableClassName="Import_PersoaneDataTable" msprop:Generator_TableVarName="tableImport_Persoane" msprop:Generator_RowChangedName="Import_PersoaneRowChanged" msprop:Generator_TablePropName="Import_Persoane" msprop:Generator_RowDeletingName="Import_PersoaneRowDeleting" msprop:Generator_RowChangingName="Import_PersoaneRowChanging" msprop:Generator_RowEvHandlerName="Import_PersoaneRowChangeEventHandler" msprop:Generator_RowDeletedName="Import_PersoaneRowDeleted" msprop:Generator_RowClassName="Import_PersoaneRow" msprop:Generator_UserTableName="Import_Persoane" msprop:Generator_RowEvArgName="Import_PersoaneRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdPersoana" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIdPersoana" msprop:Generator_ColumnPropNameInRow="IdPersoana" msprop:Generator_ColumnPropNameInTable="IdPersoanaColumn" msprop:Generator_UserColumnName="IdPersoana" type="xs:int" />
              <xs:element name="NumePrenume" msprop:Generator_ColumnVarNameInTable="columnNumePrenume" msprop:Generator_ColumnPropNameInRow="NumePrenume" msprop:Generator_ColumnPropNameInTable="NumePrenumeColumn" msprop:Generator_UserColumnName="NumePrenume">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Nume_Anterior" msprop:Generator_ColumnVarNameInTable="columnNume_Anterior" msprop:Generator_ColumnPropNameInRow="Nume_Anterior" msprop:Generator_ColumnPropNameInTable="Nume_AnteriorColumn" msprop:Generator_UserColumnName="Nume_Anterior" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cnp" msprop:Generator_ColumnVarNameInTable="columnCnp" msprop:Generator_ColumnPropNameInRow="Cnp" msprop:Generator_ColumnPropNameInTable="CnpColumn" msprop:Generator_UserColumnName="Cnp" type="xs:decimal" />
              <xs:element name="Sex" msprop:Generator_ColumnVarNameInTable="columnSex" msprop:Generator_ColumnPropNameInRow="Sex" msprop:Generator_ColumnPropNameInTable="SexColumn" msprop:Generator_UserColumnName="Sex" type="xs:short" />
              <xs:element name="DataNasterii" msprop:Generator_ColumnVarNameInTable="columnDataNasterii" msprop:Generator_ColumnPropNameInRow="DataNasterii" msprop:Generator_ColumnPropNameInTable="DataNasteriiColumn" msprop:Generator_UserColumnName="DataNasterii" type="xs:dateTime" />
              <xs:element name="IDLocNastere" msprop:Generator_ColumnVarNameInTable="columnIDLocNastere" msprop:Generator_ColumnPropNameInRow="IDLocNastere" msprop:Generator_ColumnPropNameInTable="IDLocNastereColumn" msprop:Generator_UserColumnName="IDLocNastere" type="xs:int" />
              <xs:element name="TipAI" msprop:Generator_ColumnVarNameInTable="columnTipAI" msprop:Generator_ColumnPropNameInRow="TipAI" msprop:Generator_ColumnPropNameInTable="TipAIColumn" msprop:Generator_UserColumnName="TipAI" type="xs:short" />
              <xs:element name="SeriaAI" msprop:Generator_ColumnVarNameInTable="columnSeriaAI" msprop:Generator_ColumnPropNameInRow="SeriaAI" msprop:Generator_ColumnPropNameInTable="SeriaAIColumn" msprop:Generator_UserColumnName="SeriaAI">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NumarAI" msprop:Generator_ColumnVarNameInTable="columnNumarAI" msprop:Generator_ColumnPropNameInRow="NumarAI" msprop:Generator_ColumnPropNameInTable="NumarAIColumn" msprop:Generator_UserColumnName="NumarAI">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DataElibAI" msprop:Generator_ColumnVarNameInTable="columnDataElibAI" msprop:Generator_ColumnPropNameInRow="DataElibAI" msprop:Generator_ColumnPropNameInTable="DataElibAIColumn" msprop:Generator_UserColumnName="DataElibAI" type="xs:dateTime" />
              <xs:element name="EmitentAI" msprop:Generator_ColumnVarNameInTable="columnEmitentAI" msprop:Generator_ColumnPropNameInRow="EmitentAI" msprop:Generator_ColumnPropNameInTable="EmitentAIColumn" msprop:Generator_UserColumnName="EmitentAI">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NumeTata" msprop:Generator_ColumnVarNameInTable="columnNumeTata" msprop:Generator_ColumnPropNameInRow="NumeTata" msprop:Generator_ColumnPropNameInTable="NumeTataColumn" msprop:Generator_UserColumnName="NumeTata" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NumeMama" msprop:Generator_ColumnVarNameInTable="columnNumeMama" msprop:Generator_ColumnPropNameInRow="NumeMama" msprop:Generator_ColumnPropNameInTable="NumeMamaColumn" msprop:Generator_UserColumnName="NumeMama" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StradaAdr" msprop:Generator_ColumnVarNameInTable="columnStradaAdr" msprop:Generator_ColumnPropNameInRow="StradaAdr" msprop:Generator_ColumnPropNameInTable="StradaAdrColumn" msprop:Generator_UserColumnName="StradaAdr">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDLocalitateAdr" msprop:Generator_ColumnVarNameInTable="columnIDLocalitateAdr" msprop:Generator_ColumnPropNameInRow="IDLocalitateAdr" msprop:Generator_ColumnPropNameInTable="IDLocalitateAdrColumn" msprop:Generator_UserColumnName="IDLocalitateAdr" type="xs:int" />
              <xs:element name="NrAdr" msprop:Generator_ColumnVarNameInTable="columnNrAdr" msprop:Generator_ColumnPropNameInRow="NrAdr" msprop:Generator_ColumnPropNameInTable="NrAdrColumn" msprop:Generator_UserColumnName="NrAdr">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BlocAdr" msprop:Generator_ColumnVarNameInTable="columnBlocAdr" msprop:Generator_ColumnPropNameInRow="BlocAdr" msprop:Generator_ColumnPropNameInTable="BlocAdrColumn" msprop:Generator_UserColumnName="BlocAdr">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EtajAdr" msprop:Generator_ColumnVarNameInTable="columnEtajAdr" msprop:Generator_ColumnPropNameInRow="EtajAdr" msprop:Generator_ColumnPropNameInTable="EtajAdrColumn" msprop:Generator_UserColumnName="EtajAdr" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ScaraAdr" msprop:Generator_ColumnVarNameInTable="columnScaraAdr" msprop:Generator_ColumnPropNameInRow="ScaraAdr" msprop:Generator_ColumnPropNameInTable="ScaraAdrColumn" msprop:Generator_UserColumnName="ScaraAdr" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ApartamentAdr" msprop:Generator_ColumnVarNameInTable="columnApartamentAdr" msprop:Generator_ColumnPropNameInRow="ApartamentAdr" msprop:Generator_ColumnPropNameInTable="ApartamentAdrColumn" msprop:Generator_UserColumnName="ApartamentAdr">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GradInvaliditate" msprop:Generator_ColumnVarNameInTable="columnGradInvaliditate" msprop:Generator_ColumnPropNameInRow="GradInvaliditate" msprop:Generator_ColumnPropNameInTable="GradInvaliditateColumn" msprop:Generator_UserColumnName="GradInvaliditate" type="xs:short" minOccurs="0" />
              <xs:element name="TelefonFix" msprop:Generator_ColumnVarNameInTable="columnTelefonFix" msprop:Generator_ColumnPropNameInRow="TelefonFix" msprop:Generator_ColumnPropNameInTable="TelefonFixColumn" msprop:Generator_UserColumnName="TelefonFix" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TelefonMobil" msprop:Generator_ColumnVarNameInTable="columnTelefonMobil" msprop:Generator_ColumnPropNameInRow="TelefonMobil" msprop:Generator_ColumnPropNameInTable="TelefonMobilColumn" msprop:Generator_UserColumnName="TelefonMobil">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Observatii" msprop:Generator_ColumnVarNameInTable="columnObservatii" msprop:Generator_ColumnPropNameInRow="Observatii" msprop:Generator_ColumnPropNameInTable="ObservatiiColumn" msprop:Generator_UserColumnName="Observatii" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NumarCM" msprop:Generator_ColumnVarNameInTable="columnNumarCM" msprop:Generator_ColumnPropNameInRow="NumarCM" msprop:Generator_ColumnPropNameInTable="NumarCMColumn" msprop:Generator_UserColumnName="NumarCM">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SerieCM" msprop:Generator_ColumnVarNameInTable="columnSerieCM" msprop:Generator_ColumnPropNameInRow="SerieCM" msprop:Generator_ColumnPropNameInTable="SerieCMColumn" msprop:Generator_UserColumnName="SerieCM">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CodUnitate" msprop:Generator_ColumnVarNameInTable="columnCodUnitate" msprop:Generator_ColumnPropNameInRow="CodUnitate" msprop:Generator_ColumnPropNameInTable="CodUnitateColumn" msprop:Generator_UserColumnName="CodUnitate" type="xs:short" />
              <xs:element name="NrFileCM" msprop:Generator_ColumnVarNameInTable="columnNrFileCM" msprop:Generator_ColumnPropNameInRow="NrFileCM" msprop:Generator_ColumnPropNameInTable="NrFileCMColumn" msprop:Generator_UserColumnName="NrFileCM" type="xs:short" />
              <xs:element name="NrCutieCM" msprop:Generator_ColumnVarNameInTable="columnNrCutieCM" msprop:Generator_ColumnPropNameInRow="NrCutieCM" msprop:Generator_ColumnPropNameInTable="NrCutieCMColumn" msprop:Generator_UserColumnName="NrCutieCM">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Marca" msprop:Generator_ColumnVarNameInTable="columnMarca" msprop:Generator_ColumnPropNameInRow="Marca" msprop:Generator_ColumnPropNameInTable="MarcaColumn" msprop:Generator_UserColumnName="Marca">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TelefonInterior" msprop:Generator_ColumnVarNameInTable="columnTelefonInterior" msprop:Generator_ColumnPropNameInRow="TelefonInterior" msprop:Generator_ColumnPropNameInTable="TelefonInteriorColumn" msprop:Generator_UserColumnName="TelefonInterior" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IdCasaAsigSanatate" msprop:Generator_ColumnVarNameInTable="columnIdCasaAsigSanatate" msprop:Generator_ColumnPropNameInRow="IdCasaAsigSanatate" msprop:Generator_ColumnPropNameInTable="IdCasaAsigSanatateColumn" msprop:Generator_UserColumnName="IdCasaAsigSanatate" type="xs:short" />
              <xs:element name="IdTipStudii" msprop:Generator_ColumnVarNameInTable="columnIdTipStudii" msprop:Generator_ColumnPropNameInRow="IdTipStudii" msprop:Generator_ColumnPropNameInTable="IdTipStudiiColumn" msprop:Generator_UserColumnName="IdTipStudii" type="xs:int" />
              <xs:element name="DataVechimeMunca" msprop:Generator_ColumnVarNameInTable="columnDataVechimeMunca" msprop:Generator_ColumnPropNameInRow="DataVechimeMunca" msprop:Generator_ColumnPropNameInTable="DataVechimeMuncaColumn" msprop:Generator_UserColumnName="DataVechimeMunca" type="xs:dateTime" />
              <xs:element name="UserID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" msprop:Generator_UserColumnName="UserID" type="xs:string" minOccurs="0" />
              <xs:element name="PozCutieCM" msprop:Generator_ColumnVarNameInTable="columnPozCutieCM" msprop:Generator_ColumnPropNameInRow="PozCutieCM" msprop:Generator_ColumnPropNameInTable="PozCutieCMColumn" msprop:Generator_UserColumnName="PozCutieCM" type="xs:short" />
              <xs:element name="PlatesteCAS" msprop:Generator_ColumnVarNameInTable="columnPlatesteCAS" msprop:Generator_ColumnPropNameInRow="PlatesteCAS" msprop:Generator_ColumnPropNameInTable="PlatesteCASColumn" msprop:Generator_UserColumnName="PlatesteCAS" type="xs:boolean" />
              <xs:element name="PlatesteCASS" msprop:Generator_ColumnVarNameInTable="columnPlatesteCASS" msprop:Generator_ColumnPropNameInRow="PlatesteCASS" msprop:Generator_ColumnPropNameInTable="PlatesteCASSColumn" msprop:Generator_UserColumnName="PlatesteCASS" type="xs:boolean" />
              <xs:element name="PlatesteSomaj" msprop:Generator_ColumnVarNameInTable="columnPlatesteSomaj" msprop:Generator_ColumnPropNameInRow="PlatesteSomaj" msprop:Generator_ColumnPropNameInTable="PlatesteSomajColumn" msprop:Generator_UserColumnName="PlatesteSomaj" type="xs:boolean" />
              <xs:element name="PlatesteImpozit" msprop:Generator_ColumnVarNameInTable="columnPlatesteImpozit" msprop:Generator_ColumnPropNameInRow="PlatesteImpozit" msprop:Generator_ColumnPropNameInTable="PlatesteImpozitColumn" msprop:Generator_UserColumnName="PlatesteImpozit" type="xs:boolean" />
              <xs:element name="AreDeducere" msprop:Generator_ColumnVarNameInTable="columnAreDeducere" msprop:Generator_ColumnPropNameInRow="AreDeducere" msprop:Generator_ColumnPropNameInTable="AreDeducereColumn" msprop:Generator_UserColumnName="AreDeducere" type="xs:boolean" />
              <xs:element name="DataPlecarii" msprop:Generator_ColumnVarNameInTable="columnDataPlecarii" msprop:Generator_ColumnPropNameInRow="DataPlecarii" msprop:Generator_ColumnPropNameInTable="DataPlecariiColumn" msprop:Generator_UserColumnName="DataPlecarii" type="xs:dateTime" minOccurs="0" />
              <xs:element name="MotivIncetareContract" msprop:Generator_ColumnVarNameInTable="columnMotivIncetareContract" msprop:Generator_ColumnPropNameInRow="MotivIncetareContract" msprop:Generator_ColumnPropNameInTable="MotivIncetareContractColumn" msprop:Generator_UserColumnName="MotivIncetareContract" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Operatie" msprop:Generator_ColumnVarNameInTable="columnOperatie" msprop:Generator_ColumnPropNameInRow="Operatie" msprop:Generator_ColumnPropNameInTable="OperatieColumn" msprop:Generator_UserColumnName="Operatie" type="xs:short" />
              <xs:element name="Selectat" msprop:Generator_ColumnVarNameInTable="columnSelectat" msprop:Generator_ColumnPropNameInRow="Selectat" msprop:Generator_ColumnPropNameInTable="SelectatColumn" msprop:Generator_UserColumnName="Selectat" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Import_Persoane" />
      <xs:field xpath="mstns:IdPersoana" />
    </xs:unique>
  </xs:element>
</xs:schema>